Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 3901 |
| Missing cells | 45397 |
| Missing cells (%) | 43.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 823.0 KiB |
| Average record size in memory | 216.0 B |
Variable types
| Numeric | 18 |
|---|---|
| Categorical | 9 |
Payment Method Requested Code has constant value "99.0" | Constant |
City has a high cardinality: 371 distinct values | High cardinality |
State has a high cardinality: 57 distinct values | High cardinality |
Unnamed: 0 is highly correlated with Payment Method Granted and 3 other fields | High correlation |
Postal Code is highly correlated with State | High correlation |
Credit Limit Requested is highly correlated with Payment Method Requested Code | High correlation |
Credit Limit Granted is highly correlated with Commercial Risk Cover Protected and 7 other fields | High correlation |
Commercial Risk Group Code is highly correlated with Credit Limit Granted and 8 other fields | High correlation |
Classification Decision Code is highly correlated with Credit Limit Granted and 8 other fields | High correlation |
Request Entry Date is highly correlated with Unnamed: 0 and 7 other fields | High correlation |
Effective Date is highly correlated with Payment Method Granted and 2 other fields | High correlation |
ClientePadre is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
IDCliente is highly correlated with Unnamed: 0 and 3 other fields | High correlation |
VENTASCLIENTE is highly correlated with NArticulos and 1 other fields | High correlation |
MBAvg is highly correlated with MBMin | High correlation |
MBMax is highly correlated with PrecMedArticulo | High correlation |
MBMin is highly correlated with MBAvg | High correlation |
NArticulos is highly correlated with VENTASCLIENTE and 1 other fields | High correlation |
NContratos is highly correlated with VENTASCLIENTE and 1 other fields | High correlation |
PrecMedArticulo is highly correlated with MBMax | High correlation |
DifCPrevCReal is highly correlated with Payment Method Requested Code | High correlation |
State is highly correlated with Postal Code | High correlation |
Payment Method Requested Code is highly correlated with Status Code and 6 other fields | High correlation |
Commercial Risk Cover Protected is highly correlated with Credit Limit Granted and 7 other fields | High correlation |
Payment Method Granted is highly correlated with Unnamed: 0 and 12 other fields | High correlation |
Payment Terms Granted is highly correlated with Credit Limit Granted and 7 other fields | High correlation |
Status Code is highly correlated with Credit Limit Granted and 7 other fields | High correlation |
Status is highly correlated with Credit Limit Granted and 7 other fields | High correlation |
Classification Decision is highly correlated with Credit Limit Granted and 9 other fields | High correlation |
City has 2726 (69.9%) missing values | Missing |
State has 2714 (69.6%) missing values | Missing |
Postal Code has 2707 (69.4%) missing values | Missing |
Credit Limit Requested has 2705 (69.3%) missing values | Missing |
Payment Method Requested Code has 2705 (69.3%) missing values | Missing |
Credit Limit Granted has 2705 (69.3%) missing values | Missing |
Commercial Risk Cover Protected has 2705 (69.3%) missing values | Missing |
Commercial Risk Group Code has 2705 (69.3%) missing values | Missing |
Payment Method Granted has 2705 (69.3%) missing values | Missing |
Payment Terms Granted has 2705 (69.3%) missing values | Missing |
Status Code has 2705 (69.3%) missing values | Missing |
Status has 2705 (69.3%) missing values | Missing |
Classification Decision Code has 2705 (69.3%) missing values | Missing |
Classification Decision has 2839 (72.8%) missing values | Missing |
Request Entry Date has 2705 (69.3%) missing values | Missing |
Effective Date has 2705 (69.3%) missing values | Missing |
DifCPrevCReal has 1951 (50.0%) missing values | Missing |
MBMax is highly skewed (γ1 = -32.60607807) | Skewed |
DifCPrevCReal is highly skewed (γ1 = 41.11657782) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
ClientePadre has unique values | Unique |
IDCliente has unique values | Unique |
Credit Limit Granted has 626 (16.0%) zeros | Zeros |
Commercial Risk Group Code has 676 (17.3%) zeros | Zeros |
Classification Decision Code has 134 (3.4%) zeros | Zeros |
VENTASCLIENTE has 52 (1.3%) zeros | Zeros |
MBMin has 170 (4.4%) zeros | Zeros |
PrecMedArticulo has 52 (1.3%) zeros | Zeros |
DifCPrevCReal has 231 (5.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-11-01 17:59:38.042998 |
|---|---|
| Analysis finished | 2022-11-01 18:01:15.771481 |
| Duration | 1 minute and 37.73 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 3901 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1950 |
| Minimum | 0 |
|---|---|
| Maximum | 3900 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 195 |
| Q1 | 975 |
| median | 1950 |
| Q3 | 2925 |
| 95-th percentile | 3705 |
| Maximum | 3900 |
| Range | 3900 |
| Interquartile range (IQR) | 1950 |
Descriptive statistics
| Standard deviation | 1126.266028 |
|---|---|
| Coefficient of variation (CV) | 0.5775723222 |
| Kurtosis | -1.2 |
| Mean | 1950 |
| Median Absolute Deviation (MAD) | 975 |
| Skewness | 0 |
| Sum | 7606950 |
| Variance | 1268475.167 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 2621 | 1 | < 0.1% |
| 2593 | 1 | < 0.1% |
| 2594 | 1 | < 0.1% |
| 2595 | 1 | < 0.1% |
| 2596 | 1 | < 0.1% |
| 2597 | 1 | < 0.1% |
| 2598 | 1 | < 0.1% |
| 2599 | 1 | < 0.1% |
| 2600 | 1 | < 0.1% |
| Other values (3891) | 3891 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 3900 | 1 | |
| 3899 | 1 | |
| 3898 | 1 | |
| 3897 | 1 | |
| 3896 | 1 | |
| 3895 | 1 | |
| 3894 | 1 | |
| 3893 | 1 | |
| 3892 | 1 | |
| 3891 | 1 |
| Distinct | 371 |
|---|---|
| Distinct (%) | 31.6% |
| Missing | 2726 |
| Missing (%) | 69.9% |
| Memory size | 30.6 KiB |
| PONFERRADA | 85 |
|---|---|
| FERROL | 70 |
| NARON | 64 |
| MADRID | 57 |
| A CORUÃ A | 36 |
| Other values (366) |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 8.77106383 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10306 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 253 ? |
|---|---|
| Unique (%) | 21.5% |
Sample
| 1st row | VALDOVIEO |
|---|---|
| 2nd row | EL FERROL |
| 3rd row | EL FERROL |
| 4th row | NARON |
| 5th row | FERROL |
Common Values
| Value | Count | Frequency (%) |
| PONFERRADA | 85 | 2.2% |
| FERROL | 70 | 1.8% |
| NARON | 64 | 1.6% |
| MADRID | 57 | 1.5% |
| A CORUÃ A | 36 | 0.9% |
| VIGO | 28 | 0.7% |
| ARTEIXO | 23 | 0.6% |
| VIVEIRO | 23 | 0.6% |
| LUGO | 22 | 0.6% |
| LA CORUÑA | 20 | 0.5% |
| Other values (361) | 747 | 19.1% |
| (Missing) | 2726 |
Length
| Value | Count | Frequency (%) |
| a | 139 | 8.0% |
| ponferrada | 86 | 4.9% |
| de | 83 | 4.8% |
| ferrol | 81 | 4.6% |
| naron | 64 | 3.7% |
| madrid | 59 | 3.4% |
| coruña | 50 | 2.9% |
| la | 41 | 2.4% |
| coruã | 40 | 2.3% |
| vigo | 28 | 1.6% |
| Other values (409) | 1073 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1514 | |
| R | 1169 | |
| O | 1088 | |
| E | 956 | |
| L | 598 | 5.8% |
| N | 581 | 5.6% |
| 577 | 5.6% | |
| D | 543 | 5.3% |
| I | 499 | 4.8% |
| C | 395 | 3.8% |
| Other values (46) | 2386 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 9655 | |
| Space Separator | 577 | 5.6% |
| Dash Punctuation | 19 | 0.2% |
| Lowercase Letter | 18 | 0.2% |
| Other Punctuation | 13 | 0.1% |
| Decimal Number | 13 | 0.1% |
| Open Punctuation | 6 | 0.1% |
| Close Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1514 | |
| R | 1169 | |
| O | 1088 | |
| E | 956 | |
| L | 598 | 6.2% |
| N | 581 | 6.0% |
| D | 543 | 5.6% |
| I | 499 | 5.2% |
| C | 395 | 4.1% |
| S | 350 | 3.6% |
| Other values (21) | 1962 |
Lowercase Letter
| Value | Count | Frequency (%) |
| ñ | 6 | |
| a | 3 | |
| l | 2 | 11.1% |
| â | 1 | 5.6% |
| u | 1 | 5.6% |
| r | 1 | 5.6% |
| o | 1 | 5.6% |
| e | 1 | 5.6% |
| v | 1 | 5.6% |
| i | 1 | 5.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 5 | 3 | |
| 2 | 2 | |
| 1 | 2 | |
| 4 | 1 | 7.7% |
| 7 | 1 | 7.7% |
| 3 | 1 | 7.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| ? | 5 | |
| / | 4 | |
| , | 2 | 15.4% |
| . | 2 | 15.4% |
Space Separator
| Value | Count | Frequency (%) |
| 577 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9673 | |
| Common | 633 | 6.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1514 | |
| R | 1169 | |
| O | 1088 | |
| E | 956 | |
| L | 598 | 6.2% |
| N | 581 | 6.0% |
| D | 543 | 5.6% |
| I | 499 | 5.2% |
| C | 395 | 4.1% |
| S | 350 | 3.6% |
| Other values (31) | 1980 |
Common
| Value | Count | Frequency (%) |
| 577 | ||
| - | 19 | 3.0% |
| ( | 6 | 0.9% |
| ? | 5 | 0.8% |
| ) | 5 | 0.8% |
| / | 4 | 0.6% |
| 0 | 3 | 0.5% |
| 5 | 3 | 0.5% |
| 2 | 2 | 0.3% |
| 1 | 2 | 0.3% |
| Other values (5) | 7 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10172 | |
| None | 134 | 1.3% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1514 | |
| R | 1169 | |
| O | 1088 | |
| E | 956 | |
| L | 598 | 5.9% |
| N | 581 | 5.7% |
| 577 | 5.7% | |
| D | 543 | 5.3% |
| I | 499 | 4.9% |
| C | 395 | 3.9% |
| Other values (38) | 2252 |
None
| Value | Count | Frequency (%) |
| Ã | 60 | |
| Ñ | 59 | |
| ñ | 6 | 4.5% |
| Â | 4 | 3.0% |
| Ü | 2 | 1.5% |
| â | 1 | 0.7% |
| Ó | 1 | 0.7% |
| È | 1 | 0.7% |
| Distinct | 57 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 2714 |
| Missing (%) | 69.6% |
| Memory size | 30.6 KiB |
| LA CORUñA | |
|---|---|
| LEON | |
| LUGO | |
| MADRID | |
| PONTEVEDRA | |
| Other values (52) |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 7.291491154 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8655 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | LA CORUÑA |
|---|---|
| 2nd row | LA CORU A |
| 3rd row | LA CORU A |
| 4th row | LA CORUñA |
| 5th row | LA CORUÑA |
Common Values
| Value | Count | Frequency (%) |
| LA CORUñA | 435 | 11.2% |
| LEON | 180 | 4.6% |
| LUGO | 121 | 3.1% |
| MADRID | 89 | 2.3% |
| PONTEVEDRA | 76 | 1.9% |
| LA CORUÑA | 57 | 1.5% |
| ORENSE | 39 | 1.0% |
| ASTURIAS | 27 | 0.7% |
| LA CORU A | 18 | 0.5% |
| BARCELONA | 17 | 0.4% |
| Other values (47) | 128 | 3.3% |
| (Missing) | 2714 |
Length
| Value | Count | Frequency (%) |
| la | 515 | |
| coruña | 505 | |
| leon | 180 | 10.4% |
| lugo | 122 | 7.0% |
| madrid | 91 | 5.3% |
| pontevedra | 76 | 4.4% |
| orense | 39 | 2.3% |
| asturias | 28 | 1.6% |
| a | 27 | 1.6% |
| coru | 18 | 1.0% |
| Other values (41) | 132 | 7.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1498 | |
| O | 991 | |
| L | 904 | |
| R | 824 | |
| U | 695 | |
| C | 588 | 6.8% |
| 547 | 6.3% | |
| E | 467 | 5.4% |
| ñ | 440 | 5.1% |
| N | 345 | 4.0% |
| Other values (30) | 1356 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7624 | |
| Space Separator | 547 | 6.3% |
| Lowercase Letter | 484 | 5.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1498 | |
| O | 991 | |
| L | 904 | |
| R | 824 | |
| U | 695 | |
| C | 588 | 7.7% |
| E | 467 | 6.1% |
| N | 345 | 4.5% |
| D | 283 | 3.7% |
| I | 188 | 2.5% |
| Other values (14) | 841 |
Lowercase Letter
| Value | Count | Frequency (%) |
| ñ | 440 | |
| a | 10 | 2.1% |
| r | 6 | 1.2% |
| u | 5 | 1.0% |
| d | 4 | 0.8% |
| i | 4 | 0.8% |
| o | 4 | 0.8% |
| e | 2 | 0.4% |
| s | 2 | 0.4% |
| l | 2 | 0.4% |
| Other values (5) | 5 | 1.0% |
Space Separator
| Value | Count | Frequency (%) |
| 547 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8108 | |
| Common | 547 | 6.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1498 | |
| O | 991 | |
| L | 904 | |
| R | 824 | |
| U | 695 | |
| C | 588 | 7.3% |
| E | 467 | 5.8% |
| ñ | 440 | 5.4% |
| N | 345 | 4.3% |
| D | 283 | 3.5% |
| Other values (29) | 1073 |
Common
| Value | Count | Frequency (%) |
| 547 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8147 | |
| None | 508 | 5.9% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1498 | |
| O | 991 | |
| L | 904 | |
| R | 824 | |
| U | 695 | |
| C | 588 | 7.2% |
| 547 | 6.7% | |
| E | 467 | 5.7% |
| N | 345 | 4.2% |
| D | 283 | 3.5% |
| Other values (26) | 1005 |
None
| Value | Count | Frequency (%) |
| ñ | 440 | |
| Ñ | 66 | 13.0% |
| ó | 1 | 0.2% |
| Ó | 1 | 0.2% |
| Distinct | 468 |
|---|---|
| Distinct (%) | 39.2% |
| Missing | 2707 |
| Missing (%) | 69.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22777.01508 |
| Minimum | 2400 |
|---|---|
| Maximum | 50197 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 2400 |
|---|---|
| 5-th percentile | 15000 |
| Q1 | 15320 |
| median | 24193 |
| Q3 | 28009 |
| 95-th percentile | 36810.5 |
| Maximum | 50197 |
| Range | 47797 |
| Interquartile range (IQR) | 12689 |
Descriptive statistics
| Standard deviation | 8900.51262 |
|---|---|
| Coefficient of variation (CV) | 0.3907672972 |
| Kurtosis | 0.1397390441 |
| Mean | 22777.01508 |
| Median Absolute Deviation (MAD) | 8623 |
| Skewness | 0.7268860837 |
| Sum | 27195756 |
| Variance | 79219124.91 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24400 | 44 | 1.1% |
| 15570 | 35 | 0.9% |
| 15000 | 34 | 0.9% |
| 27850 | 29 | 0.7% |
| 15190 | 24 | 0.6% |
| 15008 | 21 | 0.5% |
| 15320 | 18 | 0.5% |
| 15142 | 16 | 0.4% |
| 24402 | 16 | 0.4% |
| 15405 | 15 | 0.4% |
| Other values (458) | 942 | 24.1% |
| (Missing) | 2707 |
| Value | Count | Frequency (%) |
| 2400 | 1 | |
| 2440 | 1 | |
| 3295 | 1 | |
| 3321 | 1 | |
| 3600 | 1 | |
| 3690 | 1 | |
| 3804 | 1 | |
| 4240 | 1 | |
| 4610 | 2 | |
| 7003 | 1 |
| Value | Count | Frequency (%) |
| 50197 | 1 | |
| 50003 | 1 | |
| 49696 | 1 | |
| 48980 | 1 | |
| 48970 | 1 | |
| 48960 | 2 | |
| 48950 | 1 | |
| 48700 | 1 | |
| 48530 | 1 | |
| 48170 | 1 |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44928.92977 |
| Minimum | 10000 |
|---|---|
| Maximum | 70000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 10000 |
|---|---|
| 5-th percentile | 45000 |
| Q1 | 45000 |
| median | 45000 |
| Q3 | 45000 |
| 95-th percentile | 45000 |
| Maximum | 70000 |
| Range | 60000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1775.933729 |
|---|---|
| Coefficient of variation (CV) | 0.03952762148 |
| Kurtosis | 270.0713326 |
| Mean | 44928.92977 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -11.53372543 |
| Sum | 53735000 |
| Variance | 3153940.611 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 45000 | 1191 | |
| 70000 | 1 | < 0.1% |
| 20000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 15000 | 1 | < 0.1% |
| 10000 | 1 | < 0.1% |
| (Missing) | 2705 |
| Value | Count | Frequency (%) |
| 10000 | 1 | < 0.1% |
| 15000 | 1 | < 0.1% |
| 20000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 45000 | 1191 | |
| 70000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 70000 | 1 | < 0.1% |
| 45000 | 1191 | |
| 25000 | 1 | < 0.1% |
| 20000 | 1 | < 0.1% |
| 15000 | 1 | < 0.1% |
| 10000 | 1 | < 0.1% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Memory size | 30.6 KiB |
| 99.0 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4784 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 99.0 |
|---|---|
| 2nd row | 99.0 |
| 3rd row | 99.0 |
| 4th row | 99.0 |
| 5th row | 99.0 |
Common Values
| Value | Count | Frequency (%) |
| 99.0 | 1196 | |
| (Missing) | 2705 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 99.0 | 1196 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 2392 | |
| . | 1196 | |
| 0 | 1196 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3588 | |
| Other Punctuation | 1196 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 2392 | |
| 0 | 1196 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4784 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 2392 | |
| . | 1196 | |
| 0 | 1196 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4784 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 2392 | |
| . | 1196 | |
| 0 | 1196 |
| Distinct | 17 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16740.80268 |
| Minimum | 0 |
|---|---|
| Maximum | 45000 |
| Zeros | 626 |
| Zeros (%) | 16.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 45000 |
| 95-th percentile | 45000 |
| Maximum | 45000 |
| Range | 45000 |
| Interquartile range (IQR) | 45000 |
Descriptive statistics
| Standard deviation | 20156.11972 |
|---|---|
| Coefficient of variation (CV) | 1.204011547 |
| Kurtosis | -1.541095265 |
| Mean | 16740.80268 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.5619382697 |
| Sum | 20022000 |
| Variance | 406269162.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 626 | 16.0% |
| 45000 | 370 | 9.5% |
| 10000 | 57 | 1.5% |
| 20000 | 37 | 0.9% |
| 25000 | 19 | 0.5% |
| 15000 | 17 | 0.4% |
| 5000 | 14 | 0.4% |
| 8000 | 10 | 0.3% |
| 28000 | 7 | 0.2% |
| 30000 | 6 | 0.2% |
| Other values (7) | 33 | 0.8% |
| (Missing) | 2705 |
| Value | Count | Frequency (%) |
| 0 | 626 | |
| 3000 | 2 | 0.1% |
| 5000 | 14 | 0.4% |
| 8000 | 10 | 0.3% |
| 10000 | 57 | 1.5% |
| 12000 | 5 | 0.1% |
| 15000 | 17 | 0.4% |
| 18000 | 6 | 0.2% |
| 20000 | 37 | 0.9% |
| 22000 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 45000 | 370 | |
| 38000 | 4 | 0.1% |
| 35000 | 6 | 0.2% |
| 32000 | 5 | 0.1% |
| 30000 | 6 | 0.2% |
| 28000 | 7 | 0.2% |
| 25000 | 19 | 0.5% |
| 22000 | 5 | 0.1% |
| 20000 | 37 | 0.9% |
| 18000 | 6 | 0.2% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Memory size | 30.6 KiB |
| 0.0 | |
|---|---|
| 95.0 | |
| 50.0 | 9 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.476588629 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4158 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 95.0 |
| 4th row | 0.0 |
| 5th row | 95.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 626 | 16.0% |
| 95.0 | 561 | 14.4% |
| 50.0 | 9 | 0.2% |
| (Missing) | 2705 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0.0 | 626 | |
| 95.0 | 561 | |
| 50.0 | 9 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1831 | |
| . | 1196 | |
| 5 | 570 | 13.7% |
| 9 | 561 | 13.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2962 | |
| Other Punctuation | 1196 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1831 | |
| 5 | 570 | 19.2% |
| 9 | 561 | 18.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4158 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1831 | |
| . | 1196 | |
| 5 | 570 | 13.7% |
| 9 | 561 | 13.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4158 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1831 | |
| . | 1196 | |
| 5 | 570 | 13.7% |
| 9 | 561 | 13.5% |
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.689799331 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 676 |
| Zeros (%) | 17.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.207616248 |
|---|---|
| Coefficient of variation (CV) | 1.306436929 |
| Kurtosis | -0.8857181646 |
| Mean | 1.689799331 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.8369343879 |
| Sum | 2021 |
| Variance | 4.873569499 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 676 | 17.3% |
| 5 | 162 | 4.2% |
| 4 | 91 | 2.3% |
| 2 | 72 | 1.8% |
| 3 | 68 | 1.7% |
| 1 | 56 | 1.4% |
| 6 | 54 | 1.4% |
| 7 | 17 | 0.4% |
| (Missing) | 2705 |
| Value | Count | Frequency (%) |
| 0 | 676 | |
| 1 | 56 | 1.4% |
| 2 | 72 | 1.8% |
| 3 | 68 | 1.7% |
| 4 | 91 | 2.3% |
| 5 | 162 | 4.2% |
| 6 | 54 | 1.4% |
| 7 | 17 | 0.4% |
| Value | Count | Frequency (%) |
| 7 | 17 | 0.4% |
| 6 | 54 | 1.4% |
| 5 | 162 | 4.2% |
| 4 | 91 | 2.3% |
| 3 | 68 | 1.7% |
| 2 | 72 | 1.8% |
| 1 | 56 | 1.4% |
| 0 | 676 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Memory size | 30.6 KiB |
| 0.0 | |
|---|---|
| 99.0 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.476588629 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4158 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 99.0 |
| 4th row | 0.0 |
| 5th row | 99.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 626 | 16.0% |
| 99.0 | 570 | 14.6% |
| (Missing) | 2705 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0.0 | 626 | |
| 99.0 | 570 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1822 | |
| . | 1196 | |
| 9 | 1140 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2962 | |
| Other Punctuation | 1196 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1822 | |
| 9 | 1140 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4158 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1822 | |
| . | 1196 | |
| 9 | 1140 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4158 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1822 | |
| . | 1196 | |
| 9 | 1140 |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Memory size | 30.6 KiB |
| 0.0 | |
|---|---|
| 180.0 | |
| 150.0 | 1 |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.953177258 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4728 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 180.0 |
| 4th row | 0.0 |
| 5th row | 180.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 626 | 16.0% |
| 180.0 | 569 | 14.6% |
| 150.0 | 1 | < 0.1% |
| (Missing) | 2705 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 0.0 | 626 | |
| 180.0 | 569 | |
| 150.0 | 1 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2392 | |
| . | 1196 | |
| 1 | 570 | 12.1% |
| 8 | 569 | 12.0% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3532 | |
| Other Punctuation | 1196 | 25.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2392 | |
| 1 | 570 | 16.1% |
| 8 | 569 | 16.1% |
| 5 | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4728 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 2392 | |
| . | 1196 | |
| 1 | 570 | 12.1% |
| 8 | 569 | 12.0% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4728 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2392 | |
| . | 1196 | |
| 1 | 570 | 12.1% |
| 8 | 569 | 12.0% |
| 5 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Memory size | 30.6 KiB |
| 2.0 | |
|---|---|
| 66.0 | |
| 8.0 | 6 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.471571906 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4152 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 2.0 |
| 3rd row | 66.0 |
| 4th row | 2.0 |
| 5th row | 66.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 626 | 16.0% |
| 66.0 | 564 | 14.5% |
| 8.0 | 6 | 0.2% |
| (Missing) | 2705 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| 2.0 | 626 | |
| 66.0 | 564 | |
| 8.0 | 6 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 1196 | |
| 0 | 1196 | |
| 6 | 1128 | |
| 2 | 626 | |
| 8 | 6 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2956 | |
| Other Punctuation | 1196 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1196 | |
| 6 | 1128 | |
| 2 | 626 | |
| 8 | 6 | 0.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4152 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 1196 | |
| 0 | 1196 | |
| 6 | 1128 | |
| 2 | 626 | |
| 8 | 6 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4152 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 1196 | |
| 0 | 1196 | |
| 6 | 1128 | |
| 2 | 626 | |
| 8 | 6 | 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Memory size | 30.6 KiB |
| ANULADA | |
|---|---|
| EN VIGOR | |
| ANULADA-MANTENIMIENTO | 6 |
Length
| Max length | 21 |
|---|---|
| Median length | 7 |
| Mean length | 7.54180602 |
| Min length | 7 |
Characters and Unicode
| Total characters | 9020 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ANULADA |
|---|---|
| 2nd row | ANULADA |
| 3rd row | EN VIGOR |
| 4th row | ANULADA |
| 5th row | EN VIGOR |
Common Values
| Value | Count | Frequency (%) |
| ANULADA | 626 | 16.0% |
| EN VIGOR | 564 | 14.5% |
| ANULADA-MANTENIMIENTO | 6 | 0.2% |
| (Missing) | 2705 |
Length
Category Frequency Plot
| Value | Count | Frequency (%) |
| anulada | 626 | |
| en | 564 | |
| vigor | 564 | |
| anulada-mantenimiento | 6 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1902 | |
| N | 1214 | |
| U | 632 | 7.0% |
| L | 632 | 7.0% |
| D | 632 | 7.0% |
| E | 576 | 6.4% |
| I | 576 | 6.4% |
| O | 570 | 6.3% |
| 564 | 6.3% | |
| V | 564 | 6.3% |
| Other values (5) | 1158 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 8450 | |
| Space Separator | 564 | 6.3% |
| Dash Punctuation | 6 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1902 | |
| N | 1214 | |
| U | 632 | 7.5% |
| L | 632 | 7.5% |
| D | 632 | 7.5% |
| E | 576 | 6.8% |
| I | 576 | 6.8% |
| O | 570 | 6.7% |
| V | 564 | 6.7% |
| G | 564 | 6.7% |
| Other values (3) | 588 | 7.0% |
Space Separator
| Value | Count | Frequency (%) |
| 564 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8450 | |
| Common | 570 | 6.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 1902 | |
| N | 1214 | |
| U | 632 | 7.5% |
| L | 632 | 7.5% |
| D | 632 | 7.5% |
| E | 576 | 6.8% |
| I | 576 | 6.8% |
| O | 570 | 6.7% |
| V | 564 | 6.7% |
| G | 564 | 6.7% |
| Other values (3) | 588 | 7.0% |
Common
| Value | Count | Frequency (%) |
| 564 | ||
| - | 6 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9020 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 1902 | |
| N | 1214 | |
| U | 632 | 7.0% |
| L | 632 | 7.0% |
| D | 632 | 7.0% |
| E | 576 | 6.4% |
| I | 576 | 6.4% |
| O | 570 | 6.3% |
| 564 | 6.3% | |
| V | 564 | 6.3% |
| Other values (5) | 1158 |
| Distinct | 22 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.73745819 |
| Minimum | 0 |
|---|---|
| Maximum | 80 |
| Zeros | 134 |
| Zeros (%) | 3.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 23 |
| median | 32 |
| Q3 | 46 |
| 95-th percentile | 46 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 16.01932833 |
|---|---|
| Coefficient of variation (CV) | 0.5047451574 |
| Kurtosis | 0.4355984877 |
| Mean | 31.73745819 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.1874815949 |
| Sum | 37958 |
| Variance | 256.6188802 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46 | 353 | 9.0% |
| 23 | 185 | 4.7% |
| 32 | 144 | 3.7% |
| 0 | 134 | 3.4% |
| 35 | 99 | 2.5% |
| 29 | 67 | 1.7% |
| 21 | 65 | 1.7% |
| 30 | 31 | 0.8% |
| 65 | 27 | 0.7% |
| 33 | 20 | 0.5% |
| Other values (12) | 71 | 1.8% |
| (Missing) | 2705 |
| Value | Count | Frequency (%) |
| 0 | 134 | |
| 3 | 4 | 0.1% |
| 7 | 3 | 0.1% |
| 9 | 1 | < 0.1% |
| 20 | 12 | 0.3% |
| 21 | 65 | 1.7% |
| 23 | 185 | |
| 24 | 1 | < 0.1% |
| 25 | 14 | 0.4% |
| 26 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 80 | 12 | 0.3% |
| 74 | 4 | 0.1% |
| 65 | 27 | 0.7% |
| 58 | 3 | 0.1% |
| 55 | 1 | < 0.1% |
| 46 | 353 | |
| 40 | 13 | 0.3% |
| 35 | 99 | 2.5% |
| 33 | 20 | 0.5% |
| 32 | 144 |
| Distinct | 21 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 2839 |
| Missing (%) | 72.8% |
| Memory size | 30.6 KiB |
| SOLICITADO POR EL ASEGURADO | |
|---|---|
| DECISION CESCE | |
| DIMENSIÓN REDUCIDA | |
| PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE | |
| PATRIMONIO NETO NEGATIVO | |
| Other values (16) |
Length
| Max length | 54 |
|---|---|
| Median length | 52 |
| Mean length | 27.64783427 |
| Min length | 14 |
Characters and Unicode
| Total characters | 29362 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | VOLUMEN DE RIESGO ELEVADO |
|---|---|
| 2nd row | PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE |
| 3rd row | DECISION CESCE |
| 4th row | ANULACIÓN POR VENCIMIENTO DE LA VALIDEZ DEL SUPLEMENTO |
| 5th row | SITUACIÓN FINANCIERA AJUSTADA |
Common Values
| Value | Count | Frequency (%) |
| SOLICITADO POR EL ASEGURADO | 353 | 9.0% |
| DECISION CESCE | 185 | 4.7% |
| DIMENSIÓN REDUCIDA | 144 | 3.7% |
| PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE | 99 | 2.5% |
| PATRIMONIO NETO NEGATIVO | 67 | 1.7% |
| EXPERIENCIA COMERCIAL NEGATIVA: INCIDENCIAS EN PAGOS | 65 | 1.7% |
| SITUACIÓN FINANCIERA AJUSTADA | 31 | 0.8% |
| ANULACIÓN POR VENCIMIENTO DE LA VALIDEZ DEL SUPLEMENTO | 27 | 0.7% |
| AUSENCIA DE DATOS FINANCIEROS DE LA SOCIEDAD | 20 | 0.5% |
| GRUPO ECONÓMICO EN SITUACIÓN DELICADA | 14 | 0.4% |
| Other values (11) | 57 | 1.5% |
| (Missing) | 2839 |
Length
| Value | Count | Frequency (%) |
| el | 452 | 11.3% |
| por | 381 | 9.5% |
| asegurado | 354 | 8.8% |
| solicitado | 353 | 8.8% |
| decision | 185 | 4.6% |
| cesce | 185 | 4.6% |
| en | 180 | 4.5% |
| reducida | 144 | 3.6% |
| dimensión | 144 | 3.6% |
| de | 103 | 2.6% |
| Other values (56) | 1519 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 3330 | |
| E | 3195 | |
| 2938 | ||
| O | 2619 | |
| A | 2380 | 8.1% |
| D | 2028 | 6.9% |
| C | 1937 | 6.6% |
| S | 1808 | 6.2% |
| N | 1664 | 5.7% |
| R | 1419 | 4.8% |
| Other values (20) | 6044 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 26341 | |
| Space Separator | 2938 | 10.0% |
| Other Punctuation | 83 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 3330 | |
| E | 3195 | |
| O | 2619 | |
| A | 2380 | |
| D | 2028 | |
| C | 1937 | |
| S | 1808 | 6.9% |
| N | 1664 | 6.3% |
| R | 1419 | 5.4% |
| L | 1302 | 4.9% |
| Other values (16) | 4659 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 65 | |
| / | 16 | 19.3% |
| . | 2 | 2.4% |
Space Separator
| Value | Count | Frequency (%) |
| 2938 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 26341 | |
| Common | 3021 | 10.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 3330 | |
| E | 3195 | |
| O | 2619 | |
| A | 2380 | |
| D | 2028 | |
| C | 1937 | |
| S | 1808 | 6.9% |
| N | 1664 | 6.3% |
| R | 1419 | 5.4% |
| L | 1302 | 4.9% |
| Other values (16) | 4659 |
Common
| Value | Count | Frequency (%) |
| 2938 | ||
| : | 65 | 2.2% |
| / | 16 | 0.5% |
| . | 2 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28890 | |
| None | 472 | 1.6% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 3330 | |
| E | 3195 | |
| 2938 | ||
| O | 2619 | |
| A | 2380 | |
| D | 2028 | 7.0% |
| C | 1937 | 6.7% |
| S | 1808 | 6.3% |
| N | 1664 | 5.8% |
| R | 1419 | 4.9% |
| Other values (15) | 5572 |
None
| Value | Count | Frequency (%) |
| Ó | 258 | |
| É | 99 | 21.0% |
| Ú | 99 | 21.0% |
| Í | 13 | 2.8% |
| Á | 3 | 0.6% |
| Distinct | 380 |
|---|---|
| Distinct (%) | 31.8% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20208125.43 |
| Minimum | 20200318 |
|---|---|
| Maximum | 20221007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 20200318 |
|---|---|
| 5-th percentile | 20200318 |
| Q1 | 20200608 |
| median | 20210219.5 |
| Q3 | 20211123 |
| 95-th percentile | 20220806.75 |
| Maximum | 20221007 |
| Range | 20689 |
| Interquartile range (IQR) | 10515 |
Descriptive statistics
| Standard deviation | 7954.607502 |
|---|---|
| Coefficient of variation (CV) | 0.0003936341117 |
| Kurtosis | -1.285469961 |
| Mean | 20208125.43 |
| Median Absolute Deviation (MAD) | 9511.5 |
| Skewness | 0.4635236596 |
| Sum | 2.416891802 × 1010 |
| Variance | 63275780.52 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20200318 | 179 | 4.6% |
| 20200409 | 46 | 1.2% |
| 20200805 | 32 | 0.8% |
| 20200608 | 31 | 0.8% |
| 20200708 | 29 | 0.7% |
| 20200907 | 20 | 0.5% |
| 20201005 | 18 | 0.5% |
| 20200401 | 18 | 0.5% |
| 20210420 | 18 | 0.5% |
| 20200720 | 17 | 0.4% |
| Other values (370) | 788 | 20.2% |
| (Missing) | 2705 |
| Value | Count | Frequency (%) |
| 20200318 | 179 | |
| 20200327 | 1 | < 0.1% |
| 20200401 | 18 | 0.5% |
| 20200408 | 1 | < 0.1% |
| 20200409 | 46 | 1.2% |
| 20200413 | 1 | < 0.1% |
| 20200415 | 1 | < 0.1% |
| 20200505 | 17 | 0.4% |
| 20200506 | 2 | 0.1% |
| 20200512 | 7 | 0.2% |
| Value | Count | Frequency (%) |
| 20221007 | 1 | < 0.1% |
| 20221003 | 1 | < 0.1% |
| 20220929 | 2 | 0.1% |
| 20220928 | 1 | < 0.1% |
| 20220927 | 1 | < 0.1% |
| 20220926 | 2 | 0.1% |
| 20220923 | 15 | |
| 20220922 | 1 | < 0.1% |
| 20220920 | 2 | 0.1% |
| 20220919 | 1 | < 0.1% |
| Distinct | 244 |
|---|---|
| Distinct (%) | 20.4% |
| Missing | 2705 |
| Missing (%) | 69.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20215230.69 |
| Minimum | 20200201 |
|---|---|
| Maximum | 20221007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 20200201 |
|---|---|
| 5-th percentile | 20200608 |
| Q1 | 20210702 |
| median | 20220228 |
| Q3 | 20220601 |
| 95-th percentile | 20220901 |
| Maximum | 20221007 |
| Range | 20806 |
| Interquartile range (IQR) | 9899 |
Descriptive statistics
| Standard deviation | 6806.491913 |
|---|---|
| Coefficient of variation (CV) | 0.0003367011744 |
| Kurtosis | -0.3580692703 |
| Mean | 20215230.69 |
| Median Absolute Deviation (MAD) | 573 |
| Skewness | -0.9237217074 |
| Sum | 2.417741591 × 1010 |
| Variance | 46328332.17 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20220601 | 70 | 1.8% |
| 20220701 | 62 | 1.6% |
| 20220801 | 59 | 1.5% |
| 20220302 | 54 | 1.4% |
| 20220401 | 51 | 1.3% |
| 20220501 | 45 | 1.2% |
| 20220301 | 45 | 1.2% |
| 20210201 | 41 | 1.1% |
| 20220101 | 39 | 1.0% |
| 20200217 | 32 | 0.8% |
| Other values (234) | 698 | 17.9% |
| (Missing) | 2705 |
| Value | Count | Frequency (%) |
| 20200201 | 9 | 0.2% |
| 20200217 | 32 | |
| 20200301 | 6 | 0.2% |
| 20200319 | 1 | < 0.1% |
| 20200408 | 1 | < 0.1% |
| 20200415 | 1 | < 0.1% |
| 20200505 | 1 | < 0.1% |
| 20200506 | 1 | < 0.1% |
| 20200515 | 1 | < 0.1% |
| 20200529 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 20221007 | 2 | 0.1% |
| 20221006 | 1 | < 0.1% |
| 20221005 | 1 | < 0.1% |
| 20221004 | 2 | 0.1% |
| 20221003 | 1 | < 0.1% |
| 20221002 | 11 | |
| 20220928 | 1 | < 0.1% |
| 20220924 | 2 | 0.1% |
| 20220923 | 2 | 0.1% |
| 20220920 | 1 | < 0.1% |
| Distinct | 3901 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3376.734171 |
| Minimum | 8 |
|---|---|
| Maximum | 6378 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 277 |
| Q1 | 2169 |
| median | 3461 |
| Q3 | 4864 |
| 95-th percentile | 6049 |
| Maximum | 6378 |
| Range | 6370 |
| Interquartile range (IQR) | 2695 |
Descriptive statistics
| Standard deviation | 1792.120434 |
|---|---|
| Coefficient of variation (CV) | 0.530725945 |
| Kurtosis | -0.9967939709 |
| Mean | 3376.734171 |
| Median Absolute Deviation (MAD) | 1359 |
| Skewness | -0.21295503 |
| Sum | 13172640 |
| Variance | 3211695.649 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 8 | 1 | < 0.1% |
| 4426 | 1 | < 0.1% |
| 4381 | 1 | < 0.1% |
| 4384 | 1 | < 0.1% |
| 4386 | 1 | < 0.1% |
| 4388 | 1 | < 0.1% |
| 4390 | 1 | < 0.1% |
| 4391 | 1 | < 0.1% |
| 4392 | 1 | < 0.1% |
| 4393 | 1 | < 0.1% |
| Other values (3891) | 3891 |
| Value | Count | Frequency (%) |
| 8 | 1 | |
| 11 | 1 | |
| 12 | 1 | |
| 13 | 1 | |
| 14 | 1 | |
| 15 | 1 | |
| 16 | 1 | |
| 17 | 1 | |
| 18 | 1 | |
| 19 | 1 |
| Value | Count | Frequency (%) |
| 6378 | 1 | |
| 6375 | 1 | |
| 6367 | 1 | |
| 6361 | 1 | |
| 6359 | 1 | |
| 6356 | 1 | |
| 6354 | 1 | |
| 6353 | 1 | |
| 6352 | 1 | |
| 6350 | 1 |
| Distinct | 3901 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33767344.86 |
| Minimum | 80002 |
|---|---|
| Maximum | 63780002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 80002 |
|---|---|
| 5-th percentile | 2770007 |
| Q1 | 21690002 |
| median | 34610002 |
| Q3 | 48640002 |
| 95-th percentile | 60490002 |
| Maximum | 63780002 |
| Range | 63700000 |
| Interquartile range (IQR) | 26950000 |
Descriptive statistics
| Standard deviation | 17921202.89 |
|---|---|
| Coefficient of variation (CV) | 0.5307258524 |
| Kurtosis | -0.9967941354 |
| Mean | 33767344.86 |
| Median Absolute Deviation (MAD) | 13590000 |
| Skewness | -0.2129548645 |
| Sum | 1.317264123 × 1011 |
| Variance | 3.211695129 × 1014 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 80002 | 1 | < 0.1% |
| 44260002 | 1 | < 0.1% |
| 43810002 | 1 | < 0.1% |
| 43840002 | 1 | < 0.1% |
| 43860002 | 1 | < 0.1% |
| 43880003 | 1 | < 0.1% |
| 43900002 | 1 | < 0.1% |
| 43910002 | 1 | < 0.1% |
| 43920002 | 1 | < 0.1% |
| 43930002 | 1 | < 0.1% |
| Other values (3891) | 3891 |
| Value | Count | Frequency (%) |
| 80002 | 1 | |
| 110007 | 1 | |
| 120003 | 1 | |
| 130030 | 1 | |
| 140010 | 1 | |
| 150003 | 1 | |
| 160011 | 1 | |
| 170004 | 1 | |
| 180003 | 1 | |
| 190002 | 1 |
| Value | Count | Frequency (%) |
| 63780002 | 1 | |
| 63750002 | 1 | |
| 63670002 | 1 | |
| 63610002 | 1 | |
| 63590002 | 1 | |
| 63560002 | 1 | |
| 63540002 | 1 | |
| 63530002 | 1 | |
| 63520002 | 1 | |
| 63500002 | 1 |
| Distinct | 2124 |
|---|---|
| Distinct (%) | 54.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 536.5136132 |
| Minimum | -904.22 |
|---|---|
| Maximum | 32216.492 |
| Zeros | 52 |
| Zeros (%) | 1.3% |
| Negative | 4 |
| Negative (%) | 0.1% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | -904.22 |
|---|---|
| 5-th percentile | 12.12 |
| Q1 | 35.35 |
| median | 91.91 |
| Q3 | 311.76 |
| 95-th percentile | 2298.9866 |
| Maximum | 32216.492 |
| Range | 33120.712 |
| Interquartile range (IQR) | 276.41 |
Descriptive statistics
| Standard deviation | 1816.182784 |
|---|---|
| Coefficient of variation (CV) | 3.385156946 |
| Kurtosis | 117.999962 |
| Mean | 536.5136132 |
| Median Absolute Deviation (MAD) | 71.71 |
| Skewness | 9.305757657 |
| Sum | 2092939.605 |
| Variance | 3298519.906 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.4 | 140 | 3.6% |
| 35.35 | 130 | 3.3% |
| 12.12 | 74 | 1.9% |
| 24.24 | 61 | 1.6% |
| 29.29 | 60 | 1.5% |
| 25.25 | 58 | 1.5% |
| 0 | 52 | 1.3% |
| 30.3 | 46 | 1.2% |
| 18.18 | 42 | 1.1% |
| 20.2 | 41 | 1.1% |
| Other values (2114) | 3197 |
| Value | Count | Frequency (%) |
| -904.22 | 1 | < 0.1% |
| -545.445 | 1 | < 0.1% |
| -84.84 | 1 | < 0.1% |
| -10.53 | 1 | < 0.1% |
| 0 | 52 | |
| 0.0202 | 1 | < 0.1% |
| 0.606 | 1 | < 0.1% |
| 0.7575 | 1 | < 0.1% |
| 0.808 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 32216.492 | 1 | |
| 31651.227 | 1 | |
| 29955.642 | 1 | |
| 29217.0733 | 1 | |
| 27892.595 | 1 | |
| 21944.2605 | 1 | |
| 20148.224 | 1 | |
| 19338.4757 | 1 | |
| 17788.4931 | 1 | |
| 15871.956 | 1 |
| Distinct | 2929 |
|---|---|
| Distinct (%) | 75.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -190.0798781 |
| Minimum | -15207.6 |
|---|---|
| Maximum | 101.356 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 425 |
| Negative (%) | 10.9% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | -15207.6 |
|---|---|
| 5-th percentile | -567.501 |
| Q1 | 57.8131 |
| median | 84.1748 |
| Q3 | 92.5596 |
| 95-th percentile | 97.9745 |
| Maximum | 101.356 |
| Range | 15308.956 |
| Interquartile range (IQR) | 34.7465 |
Descriptive statistics
| Standard deviation | 1465.504305 |
|---|---|
| Coefficient of variation (CV) | -7.709939209 |
| Kurtosis | 47.18214444 |
| Mean | -190.0798781 |
| Median Absolute Deviation (MAD) | 10.8249 |
| Skewness | -6.750908172 |
| Sum | -741501.6045 |
| Variance | 2147702.868 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99.728 | 46 | 1.2% |
| 95.9801 | 17 | 0.4% |
| 97.8591 | 16 | 0.4% |
| 99.8187 | 14 | 0.4% |
| 94.3415 | 14 | 0.4% |
| 89.1793 | 13 | 0.3% |
| 91.6726 | 13 | 0.3% |
| 89.6054 | 13 | 0.3% |
| 83.0614 | 12 | 0.3% |
| 90.9795 | 11 | 0.3% |
| Other values (2919) | 3732 |
| Value | Count | Frequency (%) |
| -15207.6 | 1 | < 0.1% |
| -15086.2 | 1 | < 0.1% |
| -15079.9 | 1 | < 0.1% |
| -12186 | 3 | |
| -12185.8 | 1 | < 0.1% |
| -12185.7 | 2 | 0.1% |
| -11796.1 | 2 | 0.1% |
| -11791.7 | 6 | |
| -11791.6 | 2 | 0.1% |
| -11606.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 101.356 | 5 | 0.1% |
| 99.9322 | 1 | < 0.1% |
| 99.907 | 1 | < 0.1% |
| 99.8897 | 1 | < 0.1% |
| 99.8187 | 14 | 0.4% |
| 99.7939 | 2 | 0.1% |
| 99.7711 | 1 | < 0.1% |
| 99.7655 | 1 | < 0.1% |
| 99.728 | 46 | |
| 99.5738 | 2 | 0.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.76468905 |
| Minimum | 66.3043 |
|---|---|
| Maximum | 103.256 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 66.3043 |
|---|---|
| 5-th percentile | 99.456 |
| Q1 | 99.456 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100.103 |
| Maximum | 103.256 |
| Range | 36.9517 |
| Interquartile range (IQR) | 0.544 |
Descriptive statistics
| Standard deviation | 0.6855645268 |
|---|---|
| Coefficient of variation (CV) | 0.006871815401 |
| Kurtosis | 1509.1123 |
| Mean | 99.76468905 |
| Median Absolute Deviation (MAD) | 0.103 |
| Skewness | -32.60607807 |
| Sum | 389182.052 |
| Variance | 0.4699987203 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99.456 | 1683 | |
| 100 | 1628 | |
| 100.103 | 505 | 12.9% |
| 99.9127 | 33 | 0.8% |
| 99.8721 | 13 | 0.3% |
| 99.5711 | 11 | 0.3% |
| 103.256 | 7 | 0.2% |
| 99.6007 | 5 | 0.1% |
| 99.9275 | 4 | 0.1% |
| 99.9859 | 3 | 0.1% |
| Other values (7) | 9 | 0.2% |
| Value | Count | Frequency (%) |
| 66.3043 | 1 | < 0.1% |
| 87.1146 | 1 | < 0.1% |
| 87.8249 | 1 | < 0.1% |
| 96.0351 | 1 | < 0.1% |
| 98.5838 | 1 | < 0.1% |
| 99.4536 | 2 | 0.1% |
| 99.456 | 1683 | |
| 99.5711 | 11 | 0.3% |
| 99.6007 | 5 | 0.1% |
| 99.8087 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 103.256 | 7 | 0.2% |
| 100.103 | 505 | 12.9% |
| 100 | 1628 | |
| 99.9859 | 3 | 0.1% |
| 99.9275 | 4 | 0.1% |
| 99.9127 | 33 | 0.8% |
| 99.8721 | 13 | 0.3% |
| 99.8087 | 2 | 0.1% |
| 99.6007 | 5 | 0.1% |
| 99.5711 | 11 | 0.3% |
| Distinct | 598 |
|---|---|
| Distinct (%) | 15.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1861.663046 |
| Minimum | -45434.1 |
|---|---|
| Maximum | 99.5711 |
| Zeros | 170 |
| Zeros (%) | 4.4% |
| Negative | 1493 |
| Negative (%) | 38.3% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | -45434.1 |
|---|---|
| 5-th percentile | -9667.18 |
| Q1 | -111.962 |
| median | 41.583 |
| Q3 | 79.2665 |
| 95-th percentile | 96.0451 |
| Maximum | 99.5711 |
| Range | 45533.6711 |
| Interquartile range (IQR) | 191.2285 |
Descriptive statistics
| Standard deviation | 7828.047807 |
|---|---|
| Coefficient of variation (CV) | -4.204868235 |
| Kurtosis | 23.97687916 |
| Mean | -1861.663046 |
| Median Absolute Deviation (MAD) | 46.9013 |
| Skewness | -4.938765407 |
| Sum | -7262347.544 |
| Variance | 61278332.48 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -111.962 | 252 | 6.5% |
| 0 | 170 | 4.4% |
| -45434.1 | 108 | 2.8% |
| 88.4843 | 95 | 2.4% |
| -365.335 | 88 | 2.3% |
| -16.5 | 77 | 2.0% |
| 99.456 | 73 | 1.9% |
| -17816.7 | 62 | 1.6% |
| -9667.18 | 58 | 1.5% |
| -1206.01 | 52 | 1.3% |
| Other values (588) | 2866 |
| Value | Count | Frequency (%) |
| -45434.1 | 108 | |
| -30917.7 | 1 | < 0.1% |
| -17816.7 | 62 | |
| -14638.7 | 7 | 0.2% |
| -10057.1 | 4 | 0.1% |
| -9667.18 | 58 | |
| -8683.11 | 2 | 0.1% |
| -8412.82 | 4 | 0.1% |
| -4519.05 | 2 | 0.1% |
| -4440.64 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99.5711 | 1 | < 0.1% |
| 99.456 | 73 | |
| 99.4536 | 1 | < 0.1% |
| 99.3717 | 1 | < 0.1% |
| 99.2771 | 3 | 0.1% |
| 99.2466 | 8 | 0.2% |
| 99.2243 | 1 | < 0.1% |
| 99.1477 | 7 | 0.2% |
| 98.9339 | 18 | 0.5% |
| 98.7526 | 5 | 0.1% |
| Distinct | 571 |
|---|---|
| Distinct (%) | 14.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.00517047 |
| Minimum | 1 |
|---|---|
| Maximum | 8443 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 6 |
| Q3 | 24 |
| 95-th percentile | 251.5 |
| Maximum | 8443 |
| Range | 8442 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 315.207344 |
|---|---|
| Coefficient of variation (CV) | 4.924716889 |
| Kurtosis | 340.8852706 |
| Mean | 64.00517047 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 15.82156944 |
| Sum | 249684.17 |
| Variance | 99355.66969 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 619 | |
| 3 | 380 | 9.7% |
| 4 | 375 | 9.6% |
| 5 | 375 | 9.6% |
| 6 | 210 | 5.4% |
| 7 | 150 | 3.8% |
| 9 | 104 | 2.7% |
| 8 | 104 | 2.7% |
| 10 | 88 | 2.3% |
| 11 | 52 | 1.3% |
| Other values (561) | 1444 |
| Value | Count | Frequency (%) |
| 1 | 2 | 0.1% |
| 2 | 619 | |
| 3 | 380 | |
| 4 | 375 | |
| 5 | 375 | |
| 6 | 210 | 5.4% |
| 6.25 | 1 | < 0.1% |
| 7 | 150 | 3.8% |
| 7.375 | 1 | < 0.1% |
| 8 | 104 | 2.7% |
| Value | Count | Frequency (%) |
| 8443 | 1 | |
| 8187.5 | 1 | |
| 7173.125 | 1 | |
| 4748.625 | 1 | |
| 3836 | 1 | |
| 3414 | 1 | |
| 3174.5 | 1 | |
| 3002.5 | 1 | |
| 2964.5 | 1 | |
| 2879.5 | 1 |
| Distinct | 218 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.37605742 |
| Minimum | 1 |
|---|---|
| Maximum | 1538 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 6 |
| Q3 | 13 |
| 95-th percentile | 84 |
| Maximum | 1538 |
| Range | 1537 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 70.44508922 |
|---|---|
| Coefficient of variation (CV) | 3.29551366 |
| Kurtosis | 186.5875972 |
| Mean | 21.37605742 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 11.46698484 |
| Sum | 83388 |
| Variance | 4962.510596 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 663 | |
| 3 | 427 | 10.9% |
| 4 | 416 | 10.7% |
| 5 | 395 | 10.1% |
| 6 | 303 | 7.8% |
| 7 | 168 | 4.3% |
| 9 | 138 | 3.5% |
| 8 | 130 | 3.3% |
| 10 | 115 | 2.9% |
| 11 | 75 | 1.9% |
| Other values (208) | 1071 |
| Value | Count | Frequency (%) |
| 1 | 2 | 0.1% |
| 2 | 663 | |
| 3 | 427 | |
| 4 | 416 | |
| 5 | 395 | |
| 6 | 303 | |
| 7 | 168 | 4.3% |
| 8 | 130 | 3.3% |
| 9 | 138 | 3.5% |
| 10 | 115 | 2.9% |
| Value | Count | Frequency (%) |
| 1538 | 2 | |
| 1374 | 1 | |
| 988 | 1 | |
| 984 | 1 | |
| 947 | 1 | |
| 763 | 1 | |
| 750 | 1 | |
| 698 | 1 | |
| 576 | 1 | |
| 574 | 1 |
| Distinct | 2351 |
|---|---|
| Distinct (%) | 60.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.3535253 |
| Minimum | -24 |
|---|---|
| Maximum | 1211 |
| Zeros | 52 |
| Zeros (%) | 1.3% |
| Negative | 4 |
| Negative (%) | 0.1% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | -24 |
|---|---|
| 5-th percentile | 2.422 |
| Q1 | 8.8375 |
| median | 14.39 |
| Q3 | 25.702916 |
| 95-th percentile | 49.32 |
| Maximum | 1211 |
| Range | 1235 |
| Interquartile range (IQR) | 16.865416 |
Descriptive statistics
| Standard deviation | 30.26522307 |
|---|---|
| Coefficient of variation (CV) | 1.486976955 |
| Kurtosis | 671.801925 |
| Mean | 20.3535253 |
| Median Absolute Deviation (MAD) | 7.182027 |
| Skewness | 19.92168487 |
| Sum | 79399.1022 |
| Variance | 915.9837274 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.06 | 79 | 2.0% |
| 20.2 | 78 | 2.0% |
| 9.763333 | 62 | 1.6% |
| 10.1 | 59 | 1.5% |
| 9.09 | 59 | 1.5% |
| 8.08 | 53 | 1.4% |
| 0 | 52 | 1.3% |
| 7.07 | 51 | 1.3% |
| 15.15 | 50 | 1.3% |
| 12.625 | 49 | 1.3% |
| Other values (2341) | 3309 |
| Value | Count | Frequency (%) |
| -24 | 1 | < 0.1% |
| -22.649316 | 1 | < 0.1% |
| -14.879257 | 1 | < 0.1% |
| -1.068461 | 1 | < 0.1% |
| 0 | 52 | |
| 0.0101 | 1 | < 0.1% |
| 0.02875 | 1 | < 0.1% |
| 0.104 | 1 | < 0.1% |
| 0.159 | 1 | < 0.1% |
| 0.159555 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1211 | 1 | |
| 624.015789 | 1 | |
| 371.804 | 1 | |
| 331.28125 | 1 | |
| 319.263333 | 1 | |
| 290.682203 | 1 | |
| 290.4 | 1 | |
| 277.373333 | 1 | |
| 260.06 | 1 | |
| 241.747619 | 1 |
| Distinct | 181 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 1951 |
| Missing (%) | 50.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.49076923 |
| Minimum | -101 |
|---|---|
| Maximum | 6908 |
| Zeros | 231 |
| Zeros (%) | 5.9% |
| Negative | 585 |
| Negative (%) | 15.0% |
| Memory size | 30.6 KiB |
Quantile statistics
| Minimum | -101 |
|---|---|
| 5-th percentile | -28 |
| Q1 | -3 |
| median | 3 |
| Q3 | 9 |
| 95-th percentile | 51 |
| Maximum | 6908 |
| Range | 7009 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 160.1156094 |
|---|---|
| Coefficient of variation (CV) | 15.26252326 |
| Kurtosis | 1769.534383 |
| Mean | 10.49076923 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 41.11657782 |
| Sum | 20457 |
| Variance | 25637.00838 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 231 | 5.9% |
| 4 | 113 | 2.9% |
| 5 | 96 | 2.5% |
| 6 | 91 | 2.3% |
| 1 | 76 | 1.9% |
| 3 | 75 | 1.9% |
| 2 | 68 | 1.7% |
| 7 | 68 | 1.7% |
| -1 | 58 | 1.5% |
| -3 | 48 | 1.2% |
| Other values (171) | 1026 | |
| (Missing) | 1951 |
| Value | Count | Frequency (%) |
| -101 | 1 | < 0.1% |
| -98 | 1 | < 0.1% |
| -94 | 1 | < 0.1% |
| -87 | 1 | < 0.1% |
| -82 | 1 | < 0.1% |
| -80 | 1 | < 0.1% |
| -79 | 1 | < 0.1% |
| -75 | 1 | < 0.1% |
| -72 | 3 | |
| -71 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6908 | 1 | |
| 577 | 1 | |
| 424 | 1 | |
| 366 | 1 | |
| 357 | 1 | |
| 243 | 1 | |
| 240 | 1 | |
| 210 | 2 | |
| 203 | 1 | |
| 196 | 1 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Unnamed: 0 | City | State | Postal Code | Credit Limit Requested | Payment Method Requested Code | Credit Limit Granted | Commercial Risk Cover Protected | Commercial Risk Group Code | Payment Method Granted | Payment Terms Granted | Status Code | Status | Classification Decision Code | Classification Decision | Request Entry Date | Effective Date | ClientePadre | IDCliente | VENTASCLIENTE | MBAvg | MBMax | MBMin | NArticulos | NContratos | PrecMedArticulo | DifCPrevCReal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 8 | 80002 | 4088.0932 | 32.83660 | 100.0 | -1206.0100 | 692.50 | 224 | 15.130683 | -3.0 |
| 1 | 1 | VALDOVIEO | LA CORUÑA | 15542.0 | 45000.0 | 99.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | ANULADA | 58.0 | VOLUMEN DE RIESGO ELEVADO | 20200318.0 | 20200217.0 | 11 | 110007 | 830.1700 | -3.13485 | 100.0 | -816.4920 | 121.00 | 121 | 6.860909 | -39.0 |
| 2 | 2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 12 | 120003 | 392.2800 | 3.70088 | 100.0 | -630.3950 | 21.50 | 19 | 20.356842 | 7.0 |
| 3 | 3 | EL FERROL | LA CORU A | 15404.0 | 45000.0 | 99.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | ANULADA | 35.0 | PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE | 20200318.0 | 20210731.0 | 13 | 130030 | 2402.7208 | 73.62650 | 100.0 | -1206.0100 | 373.00 | 165 | 11.935398 | 8.0 |
| 4 | 4 | EL FERROL | LA CORU A | 15404.0 | 45000.0 | 99.0 | 45000.0 | 95.0 | 1.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 23.0 | DECISION CESCE | 20210420.0 | 20220402.0 | 14 | 140010 | 2044.0675 | 31.62250 | 100.0 | -816.4920 | 202.50 | 94 | 18.651462 | 0.0 |
| 5 | 5 | NARON | LA CORUñA | 15578.0 | 45000.0 | 99.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | ANULADA | 65.0 | ANULACIÓN POR VENCIMIENTO DE LA VALIDEZ DEL SUPLEMENTO | 20201005.0 | 20220729.0 | 15 | 150003 | 295.3400 | 82.80580 | 100.0 | 17.4219 | 13.00 | 13 | 22.718461 | 7.0 |
| 6 | 6 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 16 | 160011 | 29955.6420 | 62.08900 | 100.0 | -1076.9800 | 115.25 | 103 | 290.682203 | 29.0 |
| 7 | 7 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 17 | 170004 | 582.5000 | 91.34800 | 100.0 | 57.1962 | 155.00 | 8 | 11.562500 | 16.0 |
| 8 | 8 | FERROL | LA CORUÑA | 15404.0 | 45000.0 | 99.0 | 20000.0 | 95.0 | 3.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 30.0 | SITUACIÓN FINANCIERA AJUSTADA | 20220422.0 | 20220905.0 | 18 | 180003 | 239.8400 | 92.60940 | 100.0 | 78.1147 | 12.00 | 12 | 19.986666 | -3.0 |
| 9 | 9 | LA CORU A | LA CORU A | 15000.0 | 45000.0 | 99.0 | 45000.0 | 95.0 | 3.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 23.0 | DECISION CESCE | 20200720.0 | 20220702.0 | 19 | 190002 | 388.8300 | 25.93890 | 100.0 | -469.7170 | 24.25 | 9 | 39.475555 | -3.0 |
Last rows
| Unnamed: 0 | City | State | Postal Code | Credit Limit Requested | Payment Method Requested Code | Credit Limit Granted | Commercial Risk Cover Protected | Commercial Risk Group Code | Payment Method Granted | Payment Terms Granted | Status Code | Status | Classification Decision Code | Classification Decision | Request Entry Date | Effective Date | ClientePadre | IDCliente | VENTASCLIENTE | MBAvg | MBMax | MBMin | NArticulos | NContratos | PrecMedArticulo | DifCPrevCReal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3891 | 3891 | A CORUNA | LA CORUñA | 15008.0 | 45000.0 | 99.0 | 45000.0 | 95.0 | 5.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 35.0 | PÉRDIDAS EN EL ÚLTIMO EJERCICIO DISPONIBLE | 20220927.0 | 20220801.0 | 6350 | 63500002 | 246.54 | -135.5050 | 100.000 | -1076.9800 | 5.0 | 5 | 49.308000 | 0.0 |
| 3892 | 3892 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6352 | 63520002 | 44.44 | -84.3083 | 99.456 | -352.3810 | 3.0 | 3 | 14.813333 | NaN |
| 3893 | 3893 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6353 | 63530002 | 28.28 | 92.7194 | 100.000 | 79.2665 | 4.0 | 4 | 7.070000 | NaN |
| 3894 | 3894 | A CORUÑA | LA CORUñA | 15009.0 | 45000.0 | 99.0 | 20000.0 | 95.0 | 4.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 32.0 | DIMENSIÓN REDUCIDA | 20220929.0 | 20220801.0 | 6354 | 63540002 | 24.24 | 95.1112 | 100.000 | 87.3808 | 8.0 | 8 | 3.030000 | NaN |
| 3895 | 3895 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6356 | 63560002 | 27.27 | 96.4697 | 99.456 | 91.6705 | 3.0 | 3 | 9.090000 | NaN |
| 3896 | 3896 | RIBEIRA | LA CORUñA | 15960.0 | 45000.0 | 99.0 | 15000.0 | 95.0 | 5.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 32.0 | DIMENSIÓN REDUCIDA | 20220928.0 | 20220801.0 | 6359 | 63590002 | 10.10 | 33.1520 | 99.456 | 0.0000 | 3.0 | 3 | 3.366666 | NaN |
| 3897 | 3897 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6361 | 63610002 | 29.29 | 93.6067 | 99.456 | 88.4843 | 3.0 | 3 | 9.763333 | NaN |
| 3898 | 3898 | OVIEDO | ASTURIAS | 33004.0 | 45000.0 | 99.0 | 45000.0 | 95.0 | 0.0 | 99.0 | 180.0 | 66.0 | EN VIGOR | 0.0 | NaN | 20220929.0 | 20220801.0 | 6367 | 63670002 | 28.00 | 62.3104 | 99.456 | -16.5000 | 8.0 | 7 | 4.000000 | NaN |
| 3899 | 3899 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6375 | 63750002 | 19.19 | 96.9301 | 99.456 | 92.1549 | 3.0 | 3 | 6.396666 | NaN |
| 3900 | 3900 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6378 | 63780002 | 58.58 | -3941.1300 | 99.456 | -9667.1800 | 4.0 | 4 | 14.645000 | NaN |